EMT Practice Test

1. Question Content...

---

Question1: Which of the following SQLScript elements do you use to transform a set of arrays into an intermediate table variable?

Question2: You need to synchronize all unsynchronized changes of the remote GIT branch with a local GIT branch.
Which operation do youuse?

Question3: You need to combine data from different database tables within your OData service. Which capability do you use for this relationship?

Question4: You create an isolated block of code which runs as an independent transaction. Which of the following SQLScript features do you use?

Question5: You want to exclusively use declarative logic in an SQL Script procedure. Which of the following operators canyou use? There are 2 correct answers to this question.

Question6: You are working on an entity using Core Data Services.
Which properties can you define inside the Technical Configuration section?
Note: There are 2 correct answers to this question.

Question7: In application development with XS advanced, which of the following entities belong to a specific SPACE?
There are 2 correct answers to this question.

Question8: Why do you use associations in your persistence model for SAP HANA extended application services, advanced model (XS advanced)?

Question9: You need to create a native SAP HANA application that fully leverages the SAP HANA platform. How do you implement data-intensive calculations?

Question10: Which GIT commands are available with the SAP Web IDE for SAP HANA? Note: There are 3 correctanswers to this question.

Question11: You need to consume a Node.js service in an SAPUI5 application. In which section of the mta.xml file do you define the variable for the exposed service?
Please choose the correct answer.

Question12: To comply with the SAP Fiori principles, which view type is recommended by SAP?

Question13: You use APPLY_FILTER to add a dynamic WHERE clause on SELECT statements. On which objects can you apply the filter? There are 2 correct answers to this question.

Question14: What are the nodes where filter expressions can be used in a calculation view? There are 2 correct answers to this question.

Question15: Which elements can you specify with the SAP WeblDE for SAP HANA graphical editor for Core Data Services data models? There are 3 correct answers to this question.

Question16: What are the characteristics of the calculation view of type "SQL Access Only"? There are 2 correct answers to this question.

Question17: What are the steps to debug a Node.js application using SAP Web IDE for SAP HANA? There are 3 correct answers to this question.

Question18: Which programming paradigms are supported by SQLScript? Note: There are 2 correct answers to this question.

Question19: Which of the following models a servet-side model in the SAPUI5 context?

Question20: What are some of the advantages of SQLScript compared to plain SQL queries? There are 2 correct answers to this question.

Question21: You need to view the data model exposed by an OData V2 service. What must you append to theservice URL?

Question22: What are the key characteristics of the calculation view's Input Parameter? There are 3 correct answers to this question.

Question23: Which of the following are characteristics of SAPU15? Note; There are 3 correct answers to this question.

Question24: You need to manage an exception in a SQLScript. Which SQLScript features can you use? There are 2 correct answers to this question.

Question25: Which GIT command doyou use to consolidate all changes from one branch with another branch using a single commit?

Question26: You need to create a native SAP HANA application that fully leverages the SAP HANA platform. How do you implement data-intensive calculations?
Please choose the correct answer.

Question27: You create triggers using theSQL Console. Where are the triggers stored?

Question28: Which artifacts do you define in the persistence model to access objects in an external SAP HANA Deployment Infrastructure container?

Question29: Which tool do you use to create a calculation view in a multi-target application? Please choose the correct answer.

Question30: Which of the following are characteristics of an SAP HANA Deployment Infrastructure container? Note:
There are 3 correct answers to this question.

Question31: What are the issue categories that SQL Script Code Analyser scans for? There are 3 correct answers to this question.

Question32: In Node.js, which file do you use to define external module dependencies? Please choose the correct answer.

Question33: You must debug an existing SQLScript procedure in SAP HANA extended application services, advanced model (XS advanced).
What is the valid sequence to debug the procedure?

Question34: Which development environment does SAP recommend to develop an SAP HANA extended application services; advanced model (XS advanced) multi-target application?

Question35: From which tool can you run the XS Command Line?

Question36: What do you use to set up unit testing for your SQL Script procedure? Please choose the correct answer.

Question37: Who owns the database objects created in an SAP HANA Deployment Infrastructure (HDI) container? Please choose the correct answer.

Question38: Which URL query options are available with XSOData v2.0? Note: There are 3 correct answers to this question.

Question39: Which services can you use in SAP HANA 2.0, express edition? Note: There are 3 correct answers to this question.

Question40: Which activities do you perform on an application in the SAP HANA XS Advanced Cockpit? There are 2 correct answers to this question.

Question41: How do you debug a Node.js module in SAP Web IDE for SAP HANA? Please choose the correct answer.

Question42: How do you debug a Node.js module in SAP Web IDE for SAP HANA?

Question43: An OData Service contains an entity set called Products.
Which resource path do you add to the OData Service URL to view the available products?

Question44: To perform a specific task of an XSadvanced application, what does a user need? Please choose the correct answer.

Question45: You implement a native SAP HANA application using SAP HANA extended application services, advanced mode (XS advanced) and SAPUI5.
Where is the UI rendering executed?

Question46: Which join type is NOT supported by join optimization (pruning)? Please choose the correct answer.

Question47: Which of the following information must you specify when you create a new project in SAP Web IDE for SAP HANA? There are 2 correct answers to this question.

Question48: You created several database tables in a multi-target application and need to keep their names as short as possible. Which parameter of the .hdinamespace file do you set to ignore? Please choose the correct answer.

Question49: You implement an asynchronous Node.js service which sends requests to the database. How do you handle the database responses? Note: There are 2 correct answers to this question.

Question50: Which of the following activities are part of the development lifecycleusing SAP HANA extended application services, advanced model (XS advanced)?
Note: There are 3 correct answers to this question.

Question51: Which SAP HANA extended application services, advanced model (XS advanced) tools can you use to retrieve the URL for the SAP WeblDE for SAP HANA?
There are 2 correct answers to this question.

Question52: You need to install SAP HANA 2.0, express edition to develop a native SAP HANA application. Which of the following deployment options do you have? Note: There are 2 correct answers to this question.

Question53: You need to combine data from different database tables within your OData service. Which capability do you use for this relationship? Please choose the correct answer.

Question54: You develop a Node.js application for theSAP HANA platform that executes a SQL statement in the SAP HANA database.
Which modules do you use?
Note: There are 2 correct answers to this question.

Question55: Which of the following information must you specify when you create a new project in SAP Web IDE for SAP HANA?
Note: There are 2 correct answers to this question.

Question56: Which parameters do you need for the APPLY_FILTER function? Note: There are 2 correct answers to this question.

Question57: In Node.js, which file do you use to define external module dependencies?

Question58: Which elements can you specify with the SAP Web IDE for SAP HANA graphical editor for Core Data Services data models?
Note: There are 3 correct answers to this question.

Question59: What statement must you insert to the following OData service to complete the navigation definition from the customer entity set to the corresponding sales orders? Please choose the correct answer.
service{ "sample.odata::customer" as customer" navigates ("Customer_Orders* as "toOrders);
"sample.odata::salesorder" as "Orders";)

Question60: Which of the following activities are part of the development lifecycle using SAP HANA extended application services, advanced model (XS advanced)?
There are 2 correct answers to this question.

Question61: You are asked to produce sales value for the month using sales order line items (sales price per item x quantity sold) what do you use to achieve this in a calculated column of a calculation view? There are 2 correct answers to this question.

Question62: You work on a multi-target application that uses the SAP HANA Deployment Infrastructure (HDI).Which operations can you perform in the SAP Web IDE for SAP HANA? There are 2 correct answers to this question.

Question63: What do you reference in a role template? Please choose the correct answer.

Question64: Which tool can you use to perform an in-place upgrade of SAP HANA 2.0, express edition?

Question65: Which of the following SQL Script elements do you use to transform a set of arrays into an intermediate table variable? Please choose the correct answer.

Question66: Why do you use associations in your persistence model for SAP HANA extended application services, advanced model (XS advanced)? Please choose the correct answer.